SELECT
COUNT(SUM_PAID),
CASE
WHEN SUM_PAID > 10000 THEN 'more10'
WHEN SUM_PAID BETWEEN 5000 AND 10000 THEN '5to10'
ELSE 'less5'
END AS SaleLevel
FROM b_sale_order
GROUP BY SaleLevel;